package com.ksd.system.mapper;

import com.ksd.system.domain.SysChannel;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 频道管理Mapper接口
 * 
 * @author y.wu
 * @date 2025-01-08
 */
public interface SysChannelMapper
{
    /**
     * 查询频道管理
     * 
     * @param id 频道管理主键
     * @return 频道管理
     */
    public SysChannel selectSysChannelById(@Param("id")Long id,@Param("tableName")String tableName);

    /**
     * 查询频道管理列表
     * 
     * @param sysChannel 频道管理
     * @return 频道管理集合
     */
    public List<SysChannel> selectSysChannelList(@Param("sysChannel")SysChannel sysChannel,@Param("tableName")String tableName);

    /**
     * 新增频道管理
     * 
     * @param sysChannel 频道管理
     * @return 结果
     */
    public int insertSysChannel(@Param("sysChannel")SysChannel sysChannel,@Param("tableName")String tableName);

    /**
     * 修改频道管理
     * 
     * @param sysChannel 频道管理
     * @return 结果
     */
    public int updateSysChannel(@Param("sysChannel")SysChannel sysChannel,@Param("tableName")String tableName);

    /**
     * 删除频道管理
     * 
     * @param id 频道管理主键
     * @return 结果
     */
    public int deleteSysChannelById(@Param("id")Long id,@Param("tableName")String tableName);


    public SysChannel selectSysChannelByNameAndBoardId(@Param("name")String name, @Param("boardId")Long boardId,@Param("tableName")String tableName);

    public int clearSysChannel(@Param("tableName")String tableName);

    SysChannel selectSysChannelByName(@Param("name")String name,@Param("tableName")String tableName);

    List<SysChannel> selectSysChannelListByOrStatus(@Param("status1")String status1,@Param("status2")String status2,@Param("tableName")String tableName);

    List<SysChannel> selectSysChannelListByAndStatus(@Param("status")String status,@Param("tableName")String tableName);

    List<SysChannel> selectSysChannelListAndSelectStatus(@Param("sysChannel")SysChannel sysChannelOne,@Param("tableName")String tableName);
}
